<?php
require_once dirname(__FILE__) . '/../includes/common.inc.php';
require_once dirname(__FILE__) . '/../includes/pdoorm.inc.php';

header('Content-Type: text/plain');

$sql="
CREATE TABLE `ns_v1user` (
  `e_oid` int(12) NOT NULL AUTO_INCREMENT,
  `trackId` varchar(64) DEFAULT NULL,
  `account` varchar(64) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `email` varchar(64) DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `pEnabled` tinyint(1) DEFAULT NULL,
  `vEnabled` tinyint(1) DEFAULT NULL,
  `mEnabled` tinyint(1) DEFAULT NULL,
  `pWedding` decimal(10,2) DEFAULT NULL,
  `pPrewedding` decimal(10,2) DEFAULT NULL,
  `pPortrait` decimal(10,2) DEFAULT NULL,
  `pEngagement` decimal(10,2) DEFAULT NULL,
  `vWedding` decimal(10,2) DEFAULT NULL,
  `vPrewedding` decimal(10,2) DEFAULT NULL,
  `vPortrait` decimal(10,2) DEFAULT NULL,
  `vEngagement` decimal(10,2) DEFAULT NULL,
  `mStudio` decimal(10,2) DEFAULT NULL,
  `mHouse` decimal(10,2) DEFAULT NULL,
  `mFullDay` decimal(10,2) DEFAULT NULL,
  `lEnabled` tinyint(1) NOT NULL DEFAULT '0',
  `lightingRate` decimal(10,2) NOT NULL,
  `employmentType` int(11) NOT NULL,
  `yearlyRate` decimal(10,2) NOT NULL,
  `hourlyRate` decimal(10,2) NOT NULL,
  `commissionRate` decimal(10,2) NOT NULL,  
  PRIMARY KEY (`e_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
";

sql_execute($sql);
